Creating picture-in-picture with a shape?

Hi! I want to add a video clip over the top of a background, but instead of a sharp square, I want my clip to be in a circle or oval with softer edge. I’ve been exploring, but can’t find anything that seems to work!

Thanks for any ideas!

Is the background an image or a video (static or moving)?